<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="bj20941">COMMIT</title><body><p id="sql_command_desc">Commits the current transaction.</p><section id="section2"><title>Synopsis</title><codeblock id="sql_command_synopsis">COMMIT [WORK | TRANSACTION]</codeblock></section><section id="section3"><title>Description</title><p><codeph>COMMIT</codeph> commits the current transaction. All changes
made by the transaction become visible to others and are guaranteed to
be durable if a crash occurs. </p></section><section id="section4"><title>Parameters</title><parml><plentry><pt>WORK</pt><pt>TRANSACTION</pt><pd>Optional key words. They have no effect.</pd></plentry></parml></section><section id="section5"><title>Notes</title><p>Use <codeph><xref href="./ROLLBACK.xml#topic1" type="topic" format="dita"/></codeph> to 
        prematurely end a transaction. </p><p>Issuing <codeph>COMMIT</codeph> when not inside a transaction does
no harm, but it will provoke a warning message. </p></section><section id="section6"><title>Examples</title><p>To commit the current transaction and make all changes permanent:</p><codeblock>COMMIT;</codeblock></section><section id="section7"><title>Compatibility</title><p>The SQL standard only specifies the two forms <codeph>COMMIT</codeph>
and <codeph>COMMIT WORK</codeph>. Otherwise, this command is fully conforming.</p></section><section id="section8"><title>See Also</title><p><codeph><xref href="BEGIN.xml#topic1" type="topic" format="dita"/></codeph>, <codeph><xref
            href="./END.xml#topic1" type="topic" format="dita"/></codeph>, <codeph><xref
            href="./START_TRANSACTION.xml#topic1" type="topic" format="dita"/></codeph>,
            <codeph><xref href="./ROLLBACK.xml#topic1" type="topic" format="dita"/></codeph></p></section></body></topic>
